const add_tables = [
    "CREATE TABLE IF NOT EXISTS \"Sym_user\" (\n" +
                "  \"kid\" varchar(36) NOT NULL,\n" +
                "  \"user_id\" INTEGER,\n" +
                "  \"user_name\" varchar(30),\n" +
                "  \"password\" varchar(30),\n" +
                "  \"is_del\" boolean,\n" +
                "  \"add_date\" Date,\n" +
                "  PRIMARY KEY (\"kid\")\n" +
                "); ",
]

const alter_tables = [
    {
        tableName: 'Sym_user',
        field: "email",
        sql: "alter table Sym_user add column email varchar"
    }
]

const add_indexs = [
    "create index if not exists indx_user_id"+
    " on Sym_user ("+
    " user_id desc );"
]

export {
    add_tables,
    alter_tables,
    add_indexs
}